﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebApplication1.Tools
{
    public partial class 表结构 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                StringBuilder sb = new StringBuilder();
                int i = 1;
                var tableList = new CommonLib.DbHelper.Table().DicTable;
                foreach (var item in tableList)
                {
                    sb.Append("<tr><td colspan='2' class='blod'>" + i + "、" + item.Key + "   " + item.Value.Comments + "</td></tr>");
                    foreach (var column in item.Value.Columns)
                    {
                        sb.Append(string.Format("<tr><td width='150px'>{0}</td><td>{1}</td></tr>", column.Name, column.Comments));
                    }
                    i++;
                }
                Literal1.Text = sb.ToString();
            }
        }
    }
}